package tripService;

import com.jfinal.plugin.activerecord.Page;

import tripModel.Location;

public class LocationService {
	public static final Page<Location> findLocationByTotal(Long tID, int pageNumber) {
		// String sql = "select l.`lID`,l.`lName`,l.`lintro`,li.`liimgPath` from
		// `location` l inner join limg li on l.lID=li.lilID where l.lTID=? ";
		return Location.dao.paginate(pageNumber, 6, "select l.`lID`,l.`lName`,l.`lintro`,li.`liimgPath`",
				"from `location` l left join limg li on l.lID=li.lilID where l.lTID=?", tID);
	}
}
